/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 60004
Source Host           : localhost:3306
Source Database       : trabalhojava

Target Server Type    : MYSQL
Target Server Version : 60099
File Encoding         : 65001

Date: 2013-11-23 16:16:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cliente`
-- ----------------------------
DROP TABLE IF EXISTS `cliente`;
CREATE TABLE `cliente` (
`nome`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`sobrenome`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`rg`  varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`cpf`  int(11) NOT NULL ,
`endereco`  varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`numConta`  int(10) NOT NULL ,
`salario`  double NOT NULL ,
`codClinete`  int(10) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`codClinete`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of cliente
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `conta`
-- ----------------------------
DROP TABLE IF EXISTS `conta`;
CREATE TABLE `conta` (
`numConta`  int(10) NOT NULL AUTO_INCREMENT ,
`tipo`  int(1) NOT NULL ,
`saldo`  double NOT NULL ,
PRIMARY KEY (`numConta`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of conta
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `contacorrente`
-- ----------------------------
DROP TABLE IF EXISTS `contacorrente`;
CREATE TABLE `contacorrente` (
`numContaCor`  int(10) NOT NULL AUTO_INCREMENT ,
`depositoInicial`  double NOT NULL ,
`limite`  double NOT NULL ,
`conta`  int(10) NOT NULL ,
PRIMARY KEY (`numContaCor`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of contacorrente
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `containvestimento`
-- ----------------------------
DROP TABLE IF EXISTS `containvestimento`;
CREATE TABLE `containvestimento` (
`numContaInvest`  int(10) NOT NULL AUTO_INCREMENT ,
`montanteMin`  double NOT NULL ,
`depositoMin`  double NOT NULL ,
`depositoInicial`  double NOT NULL ,
`conta`  int(10) NOT NULL ,
PRIMARY KEY (`numContaInvest`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of containvestimento
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Auto increment value for `cliente`
-- ----------------------------
ALTER TABLE `cliente` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `conta`
-- ----------------------------
ALTER TABLE `conta` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table contacorrente
-- ----------------------------
CREATE INDEX `conta` ON `contacorrente`(`conta`) USING BTREE ;

-- ----------------------------
-- Auto increment value for `contacorrente`
-- ----------------------------
ALTER TABLE `contacorrente` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table containvestimento
-- ----------------------------
CREATE INDEX `conta` ON `containvestimento`(`conta`) USING BTREE ;

-- ----------------------------
-- Auto increment value for `containvestimento`
-- ----------------------------
ALTER TABLE `containvestimento` AUTO_INCREMENT=1;
